Microsoft Excel - Pivot Tables and Charts

Join the Microsoft Excel - Pivot Tables and Charts course and develop the ability to condense vast volumes of data into useful information. You will learn all there is to know about the PivotTable and PivotChart in this course, including how they operate.

This course will teach you the essentials of the pivot table and pivot charts and will help you comprehend the content fast. You will learn how to analyse pivot tables and pivot chart data. This course will teach you how to visualise data with charts, modify charts, and many other important topics.

You have come to the correct spot if you are searching for a fast refresher on Excel Pivot Tables, want to diversify your Excel skill set, or want to significantly raise your analytics game. Analytical skills are in high demand and limited supply in today's increasingly data-driven world. Those with specific skills are leading the push. So, don't waste your time. Enrol right away to begin your path to Excel analytics mastery!

Learning Outcomes

Upon successful completion of the Microsoft Excel - Pivot Tables and Charts course, you will be able to,

• Create a pivot table and analyse its data.
• Learn how to present data with pivot charts.
• Determine how to present pivot table data visually.
• Explore the fundamentals of creating charts, modifying, and formatting processes.
• Use advanced chart features.
• Recognise the importance of using lookup functions and formula auditing.

Benefits of studying Pivot Tables and Charts in Excel:

• 24/7 access to the course for 12 months
• Full Tutor support on weekdays (Monday – Friday)
• Efficient exam system, assessment and instant results
• Improve your chance of gaining professional skills and better earning potential.

The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.

You are taught through a combination of

• Video lessons
• Online study materials

Course design

This course is designed with the following modules:

PivotTables and PivotCharts

• Create a PivotTable
• Analyze PivotTable Data
• Present Data with PivotCharts
• Filter Data by Using Timelines and Slicers
• Analyze Data with PivotCharts
• Present PivotTable Data Visually

Visualizing Data with Charts

• Create Charts
• Modify and Format Charts
• Use Advanced Chart Features
• Create a Trendline
• Create Advanced Charts

Using Lookup Functions and Formula Auditing

• Use Lookup Functions
• Trace Cells
• Watch and Evaluate Formulas

How is the course assessed?

This course does not involve any assessment.

Exam & Retakes:

It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable.

Certification

Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery).

• Professionals looking to expand their knowledge of Microsoft Excel
• People who are interested in the advanced features of Microsoft Excel.
• Excel users who are skilled with the basics but want to improve their data exploration and analytical skills.

The Microsoft Excel - Pivot Tables and Charts course will assist you with developing a specific demanding skill that will be useful in the following careers:

• Office Administrator
• Office Manager
• Accountants

In the United Kingdom, the average yearly salary for these vocations is between £22,000 and £28,000.

Currently there are no Q&As for this course. Be the first to ask a question.